[dbo].[aspnet_Personalization

[dbo].[aspnet_Personalization_GetApplicationId]

SQLServer > iMIS1521GA > Stored Procedures > dbo.aspnet_Personalization_GetApplicationId

Properties
Parameters
Permissions
SQL Script
Uses
Used By

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)	Direction
@ApplicationName	nvarchar(256)	512
@ApplicationId	uniqueidentifier	16	Out

Permissions

Type	Action	Owning Principal
Grant	Execute	aspnet_Personalization_BasicAccess

SQL Script

SET ANSI_NULLS OFF
GO
CREATE PROCEDURE dbo.aspnet_Personalization_GetApplicationId (
    @ApplicationName NVARCHAR(256),
    @ApplicationId UNIQUEIDENTIFIER OUT)
AS
BEGIN
    SELECT @ApplicationId = ApplicationId FROM dbo.aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
END
GO
GRANT EXECUTE ON  [dbo].[aspnet_Personalization_GetApplicationId] TO [aspnet_Personalization_BasicAccess]
GO

Uses

[dbo].[aspnet_Applications]
dbo

Used By

[dbo].[aspnet_PersonalizationAdministration_DeleteAllState]
[dbo].[aspnet_PersonalizationAdministration_FindState]
[dbo].[aspnet_PersonalizationAdministration_GetCountOfState]
[dbo].[aspnet_PersonalizationAdministration_ResetSharedState]
[dbo].[aspnet_PersonalizationAdministration_ResetUserState]
[dbo].[aspnet_PersonalizationAllUsers_GetPageSettings]
[dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings]
[dbo].[aspnet_PersonalizationPerUser_GetPageSettings]
[dbo].[aspnet_PersonalizationPerUser_ResetPageSettings]